# name : import from xls using file formats
# key : import.xls
# contributor: Shuguang Sun
# --
filename ${1:infname} '${2:fname}';
%let __omsglevel__=%sysfunc(getoption(msglevel));
options msglevel=i;
proc import out=${3:dout} datafile=$1 dbms=xls replace;
  sheet="${4:sheetname}";
  range="name" | "sheet$ul:lr";
  getnames=yes;
  datarow=2;
  startcol=;
  startrow=;
run;
options msglevel=__omsglevel__;
filename $1 clear;